github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/many controls/queries/q6.sql (about)

     1  -- Required Columns
     2  select arn as resource,
     3         case
     4             when users is null then 'alarm'
     5             else 'ok'
     6             end as status,
     7         case
     8             when users is null then title || ' not associated with any IAM user.'
     9             else title || ' associated with IAM user.'
    10             end as reason,
    11         -- Additional Dimensions
    12         account_id
    13  from
    14      aws_iam_group;